# -*- coding: utf-8 -*-
import time

import pymysql


class Question():

    def __init__(self):
        self.conn = pymysql.connect(host="localhost", user="root", password="123456", db="yikaobang", port=3306,
                               charset='utf8')
        self.client = self.conn.cursor(cursor=pymysql.cursors.DictCursor)

    def show(self):
        sql = 'select * from QUESTION_INFO_BEAN where id < 1000'
        self.client.execute(sql)
        data = self.client.fetchall()

        return data